Pandas Profiling Report

Dataset info

Number of variables	16
Number of observations	374860
Missing cells	0 (0.0%)
Duplicate rows	0 (0.0%)
Total size in memory	45.8 MiB
Average record size in memory	128.0 B

Variables types

Numeric	6
Categorical	8
Boolean	0
Date	0
URL	0
Text (Unique)	0
Rejected	2
Unsupported	0

Warnings

`backers` is highly skewed (γ1 = 86.34074093)	Skewed
`backers` has 51811 (13.8%) zeros	Zeros
`category` has a high cardinality: 159 distinct values	Warning
`deadline` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`deadline` has a high cardinality: 3164 distinct values	Warning
`goal` is highly skewed (γ1 = 70.44444164)	Skewed
`launched` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`launched` has a high cardinality: 374298 distinct values	Warning
`name` has a high cardinality: 372068 distinct values	Warning
`pledged` is highly skewed (γ1 = 74.9629582)	Skewed
`pledged` has 51808 (13.8%) zeros	Zeros
`usd_goal_real` is highly correlated with `goal` (ρ = 0.9426905837)	Rejected
`usd_pledged` is highly skewed (γ1 = 105.8993653)	Skewed
`usd_pledged` has 68111 (18.2%) zeros	Zeros
`usd_pledged_real` is highly correlated with `usd_pledged` (ρ = 0.9077433634)	Rejected

backers
Numeric

Distinct count	3963
Unique (%)	1.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	106.6883663
Minimum	0
Maximum	219382
Zeros (%)	13.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
Median	12
Q3	57
95-th percentile	338
Maximum	219382
Range	219382
Interquartile range	55

Descriptive statistics

Standard deviation	911.7101242
Coef of variation	8.545543958
Kurtosis	13818.22311
Mean	106.6883663
MAD	147.8618611
Skewness	86.34074093
Sum	39993201
Variance	831215.3506
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 1.50000e+00 2.50000e+00 3.50000e+00 ... 1.28190e+04 1.85810e+04 3.68220e+04 8.93635e+04 2.19382e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	51811	13.8%
1	34868	9.3%
2	23196	6.2%
3	16063	4.3%
4	12068	3.2%
5	9715	2.6%
6	8137	2.2%
7	7014	1.9%
8	6198	1.7%
9	5553	1.5%
Other values (3953)	200237	53.4%

Minimum 5 values

Value	Count	Frequency (%)
0	51811	13.8%
1	34868	9.3%
2	23196	6.2%
3	16063	4.3%
4	12068	3.2%

Maximum 5 values

Value	Count	Frequency (%)
219382	1	< 0.1%
154926	1	< 0.1%
105857	1	< 0.1%
91585	1	< 0.1%
87142	1	< 0.1%

category
Categorical

Distinct count	159
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Product Design	22310
Documentary	16138
Tabletop Games	14178
Other values (156)	322234

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Product Design	22310	6.0%
Documentary	16138	4.3%
Tabletop Games	14178	3.8%
Music	13340	3.6%
Shorts	12357	3.3%
Video Games	11828	3.2%
Food	11492	3.1%
Film & Video	9224	2.5%
Fiction	9168	2.4%
Fashion	8554	2.3%
Other values (149)	246271	65.7%

Max length	18
Mean length	9.062695406
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

country
Categorical

Distinct count	22
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

US	292624
GB	33671
CA	14756
Other values (19)	33809

Toggle details

Common values
Composition

Value	Count	Frequency (%)
US	292624	78.1%
GB	33671	9.0%
CA	14756	3.9%
AU	7839	2.1%
DE	4171	1.1%
FR	2939	0.8%
IT	2878	0.8%
NL	2868	0.8%
ES	2276	0.6%
SE	1757	0.5%
Other values (12)	9081	2.4%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

currency
Categorical

Distinct count	14
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

USD	292624
GBP	33671
EUR	17219
Other values (11)	31346

Toggle details

Common values
Composition

Value	Count	Frequency (%)
USD	292624	78.1%
GBP	33671	9.0%
EUR	17219	4.6%
CAD	14756	3.9%
AUD	7839	2.1%
SEK	1757	0.5%
MXN	1752	0.5%
NZD	1447	0.4%
DKK	1113	0.3%
CHF	761	0.2%
Other values (4)	1921	0.5%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

deadline
Categorical

Distinct count	3164
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0

2014-08-08	702
2014-08-10	556
2014-08-07	541
Other values (3161)	373061

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2014-08-08	702	0.2%
2014-08-10	556	0.1%
2014-08-07	541	0.1%
2014-08-09	473	0.1%
2015-05-01	463	0.1%
2015-07-01	437	0.1%
2014-08-15	421	0.1%
2015-04-01	420	0.1%
2014-08-14	411	0.1%
2014-08-31	411	0.1%
Other values (3154)	370025	98.7%

Max length	10
Mean length	10
Min length	10
Contains chars	False
Contains digits	True
Contains spaces	False
Contains non-words	True

df_index
Numeric

Distinct count	374860
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	189316.3371
Minimum	0
Maximum	378660
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	18947.95
Q1	94645.75
Median	189315.5
Q3	283972.25
95-th percentile	359724.05
Maximum	378660
Range	378660
Interquartile range	189326.5

Descriptive statistics

Standard deviation	109311.5669
Coef of variation	0.5774016579
Kurtosis	-1.200108674
Mean	189316.3371
MAD	94667.33873
Skewness	0.000113888787
Sum	7.096712214e+10
Variance	1.194901867e+10
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 378660.], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	1	< 0.1%
72310	1	< 0.1%
92792	1	< 0.1%
90745	1	< 0.1%
96890	1	< 0.1%
84604	1	< 0.1%
82557	1	< 0.1%
88702	1	< 0.1%
86655	1	< 0.1%
305856	1	< 0.1%
Other values (374850)	374850	> 99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
378660	1	< 0.1%
378659	1	< 0.1%
378658	1	< 0.1%
378657	1	< 0.1%
378656	1	< 0.1%

goal
Numeric

Distinct count	8312
Unique (%)	2.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	49522.98884
Minimum	0.01
Maximum	100000000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.01
5-th percentile	400
Q1	2000
Median	5500
Q3	16500
95-th percentile	90000
Maximum	100000000
Range	99999999.99
Interquartile range	14500

Descriptive statistics

Standard deviation	1189361.601
Coef of variation	24.0163534
Kurtosis	5519.119935
Mean	49522.98884
MAD	73440.87686
Skewness	70.44444164
Sum	1.85641876e+10
Variance	1.414581018e+12
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.0000000e-02 7.5000000e-01 1.4250000e+00 4.5000000e+00 5.5000000e+00 ... 1.0029933e+07 2.5500000e+07 5.6500000e+07 9.9500000e+07 1.0000000e+08], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5000	29180	7.8%
10000	25980	6.9%
1000	16876	4.5%
3000	15348	4.1%
2000	14903	4.0%
15000	14222	3.8%
20000	13092	3.5%
500	11597	3.1%
2500	11589	3.1%
25000	10365	2.8%
Other values (8302)	211708	56.5%

Minimum 5 values

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.15	1	< 0.1%
0.5	1	< 0.1%
1	430	0.1%
1.85	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
100000000	36	< 0.1%
99000000	2	< 0.1%
80000000	2	< 0.1%
75000000	1	< 0.1%
73000000	1	< 0.1%

ID
Numeric

Distinct count	374860
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1074652356
Minimum	5971
Maximum	2147476221
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5971
5-th percentile	108665913.6
Q1	538063323
Median	1075289160
Q3	1610137351
95-th percentile	2039710999
Maximum	2147476221
Range	2147470250
Interquartile range	1072074028

Descriptive statistics

Standard deviation	619136772.6
Coef of variation	0.5761274978
Kurtosis	-1.198059604
Mean	1074652356
MAD	536084923.8
Skewness	-0.002572662134
Sum	4.02844182e+14
Variance	3.833303432e+17
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[5.97100000e+03 2.14747622e+09], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1294469119	1	< 0.1%
19964225	1	< 0.1%
1371058499	1	< 0.1%
2010155332	1	< 0.1%
400589125	1	< 0.1%
794451597	1	< 0.1%
487139804	1	< 0.1%
292614771	1	< 0.1%
644411723	1	< 0.1%
486666825	1	< 0.1%
Other values (374850)	374850	> 99.9%

Minimum 5 values

Value	Count	Frequency (%)
5971	1	< 0.1%
18520	1	< 0.1%
21109	1	< 0.1%
21371	1	< 0.1%
24380	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2147476221	1	< 0.1%
2147472329	1	< 0.1%
2147466649	1	< 0.1%
2147460119	1	< 0.1%
2147455254	1	< 0.1%

launched
Categorical

Distinct count	374298
Unique (%)	99.9%
Missing (%)	0.0%
Missing (n)	0

1970-01-01 01:00:00	7
2014-07-08 19:55:03	2
2017-03-20 20:11:00	2
Other values (374295)	374849

Toggle details

Common values
Composition

Value	Count	Frequency (%)
1970-01-01 01:00:00	7	< 0.1%
2014-07-08 19:55:03	2	< 0.1%
2017-03-20 20:11:00	2	< 0.1%
2014-11-11 22:00:42	2	< 0.1%
2014-07-10 16:00:06	2	< 0.1%
2017-08-07 18:49:57	2	< 0.1%
2017-02-07 22:00:01	2	< 0.1%
2017-01-31 18:06:47	2	< 0.1%
2015-02-24 00:32:16	2	< 0.1%
2015-02-20 03:29:57	2	< 0.1%
Other values (374288)	374835	> 99.9%

Max length	19
Mean length	19
Min length	19
Contains chars	False
Contains digits	True
Contains spaces	True
Contains non-words	True

main_category
Categorical

Distinct count	15
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Film & Video	62696
Music	49530
Publishing	39379
Other values (12)	223255

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Film & Video	62696	16.7%
Music	49530	13.2%
Publishing	39379	10.5%
Games	35225	9.4%
Technology	32562	8.7%
Design	30066	8.0%
Art	28152	7.5%
Food	24599	6.6%
Fashion	22812	6.1%
Theater	10912	2.9%
Other values (5)	38927	10.4%

Max length	12
Mean length	7.462930161
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

name
Categorical

Distinct count	372068
Unique (%)	99.3%
Missing (%)	0.0%
Missing (n)	0

New EP/Music Development	13
Canceled (Canceled)	13
Music Video	11
Other values (372065)	374823

Toggle details

Common values
Composition

Value	Count	Frequency (%)
New EP/Music Development	13	< 0.1%
Canceled (Canceled)	13	< 0.1%
Music Video	11	< 0.1%
N/A (Canceled)	11	< 0.1%
New EP / Music Development	10	< 0.1%
Cancelled (Canceled)	10	< 0.1%
Debut Album	9	< 0.1%
Reflections	9	< 0.1%
The Journey	9	< 0.1%
The Other Side	8	< 0.1%
Other values (372058)	374757	> 99.9%

Max length	96
Mean length	34.86675292
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

pledged
Numeric

Distinct count	61936
Unique (%)	16.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9750.538301
Minimum	0
Maximum	20338986.27
Zeros (%)	13.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	31
Median	620
Q3	4080
95-th percentile	30010.05
Maximum	20338986.27
Range	20338986.27
Interquartile range	4049

Descriptive statistics

Standard deviation	96010.93751
Coef of variation	9.846732
Kurtosis	9952.710565
Mean	9750.538301
MAD	14311.86115
Skewness	74.9629582
Sum	3655086787
Variance	9218100121
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 1.00500000e+00 1.24000000e+00 1.99500000e+00 ... 1.12389844e+06 1.73035349e+06 3.41529830e+06 6.81926975e+06 2.03389863e+07], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	51808	13.8%
1	9023	2.4%
10	4982	1.3%
25	3958	1.1%
50	3594	1.0%
5	3577	1.0%
20	3196	0.9%
100	3030	0.8%
2	2399	0.6%
30	2110	0.6%
Other values (61926)	287183	76.6%

Minimum 5 values

Value	Count	Frequency (%)
0	51808	13.8%
1	9023	2.4%
1.01	5	< 0.1%
1.02	3	< 0.1%
1.03	3	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
20338986.27	1	< 0.1%
13285226.36	1	< 0.1%
12779843.49	1	< 0.1%
12393139.69	1	< 0.1%
10266845.74	1	< 0.1%

state
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

failed	197611
successful	133851
canceled	38757
Other values (2)	4641

Toggle details

Common values
Composition

Value	Count	Frequency (%)
failed	197611	52.7%
successful	133851	35.7%
canceled	38757	10.3%
live	2798	0.7%
suspended	1843	0.5%

Max length	10
Mean length	7.634879688
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

usd_goal_real
Highly correlated

This variable is highly correlated with goal and should be ignored for analysis

Correlation	0.9426905837

usd_pledged
Numeric

Distinct count	95454
Unique (%)	25.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7036.802252
Minimum	0
Maximum	20338986.27
Zeros (%)	18.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	16.98
Median	394.765
Q3	3034.425
95-th percentile	22433.0475
Maximum	20338986.27
Range	20338986.27
Interquartile range	3017.445

Descriptive statistics

Standard deviation	78640.16167
Coef of variation	11.17555373
Kurtosis	18960.72249
Mean	7036.802252
MAD	10320.83182
Skewness	105.8993653
Sum	2637815692
Variance	6184275027
Memory size	2.9 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 2.35000000e-01 5.55000000e-01 7.05000000e-01 7.45000000e-01 ... 9.43430540e+05 1.64513623e+06 3.41529830e+06 6.27932538e+06 2.03389863e+07], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	68111	18.2%
1	5341	1.4%
25	3877	1.0%
10	3624	1.0%
50	3141	0.8%
100	2673	0.7%
5	2598	0.7%
20	2473	0.7%
30	1717	0.5%
2	1451	0.4%
Other values (95444)	279854	74.7%

Minimum 5 values

Value	Count	Frequency (%)
0	68111	18.2%
0.47	3	< 0.1%
0.48	1	< 0.1%
0.51	1	< 0.1%
0.52	3	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
20338986.27	1	< 0.1%
13285226.36	1	< 0.1%
12779843.49	1	< 0.1%
10266845.74	1	< 0.1%
9192055.66	1	< 0.1%

usd_pledged_real
Highly correlated

This variable is highly correlated with usd_pledged and should be ignored for analysis

Correlation	0.9077433634

Count
Matrix

First rows

	backers	category	country	currency	deadline	df_index	goal	ID	launched	main_category	name	pledged	state	usd_goal_real	usd_pledged	usd_pledged_real
0	0	Poetry	GB	GBP	2015-10-09	0	1000.0	1000002330	2015-08-11 12:12:28	Publishing	The Songs of Adelaide & Abullah	0.00	failed	1533.95	0.00	0.00
1	15	Narrative Film	US	USD	2017-11-01	1	30000.0	1000003930	2017-09-02 04:43:57	Film & Video	Greeting From Earth: ZGAC Arts Capsule For ET	2421.00	failed	30000.00	100.00	2421.00
2	3	Narrative Film	US	USD	2013-02-26	2	45000.0	1000004038	2013-01-12 00:20:50	Film & Video	Where is Hank?	220.00	failed	45000.00	220.00	220.00
3	1	Music	US	USD	2012-04-16	3	5000.0	1000007540	2012-03-17 03:24:11	Music	ToshiCapital Rekordz Needs Help to Complete Album	1.00	failed	5000.00	1.00	1.00
4	14	Film & Video	US	USD	2015-08-29	4	19500.0	1000011046	2015-07-04 08:35:03	Film & Video	Community Film Project: The Art of Neighborhoo...	1283.00	canceled	19500.00	1283.00	1283.00
5	224	Restaurants	US	USD	2016-04-01	5	50000.0	1000014025	2016-02-26 13:38:27	Food	Monarch Espresso Bar	52375.00	successful	50000.00	52375.00	52375.00
6	16	Food	US	USD	2014-12-21	6	1000.0	1000023410	2014-12-01 18:30:44	Food	Support Solar Roasted Coffee & Green Energy! ...	1205.00	successful	1000.00	1205.00	1205.00
7	40	Drinks	US	USD	2016-03-17	7	25000.0	1000030581	2016-02-01 20:05:12	Food	Chaser Strips. Our Strips make Shots their B*tch!	453.00	failed	25000.00	453.00	453.00
8	58	Product Design	US	USD	2014-05-29	8	125000.0	1000034518	2014-04-24 18:14:43	Design	SPIN - Premium Retractable In-Ear Headphones w...	8233.00	canceled	125000.00	8233.00	8233.00
9	43	Documentary	US	USD	2014-08-10	9	65000.0	100004195	2014-07-11 21:55:48	Film & Video	STUDIO IN THE SKY - A Documentary Feature Film...	6240.57	canceled	65000.00	6240.57	6240.57

Last rows

	backers	category	country	currency	deadline	df_index	goal	ID	launched	main_category	name	pledged	state	usd_goal_real	usd_pledged	usd_pledged_real
374850	78	Classical Music	CA	CAD	2014-03-22	378651	5000.0	999969812	2014-02-20 01:00:16	Music	AT THE BEACH	5501.0	successful	4529.81	5019.92	4983.69
374851	36	Documentary	NO	NOK	2015-04-28	378652	20000.0	999971898	2015-03-29 21:30:33	Film & Video	Beach Wrestling Documentary	21500.0	successful	2675.19	2698.97	2875.83
374852	1	Documentary	US	USD	2012-03-16	378653	1700.0	999972264	2012-02-15 04:31:10	Film & Video	Islanda	25.0	failed	1700.00	25.00	25.00
374853	4	Small Batch	US	USD	2017-04-19	378654	6500.0	999975836	2017-03-20 22:08:22	Food	Homemade fresh dog food, Cleveland OH	154.0	failed	6500.00	0.00	154.00
374854	0	Poetry	CA	CAD	2014-09-20	378655	5500.0	999976312	2014-08-06 03:46:07	Publishing	Angela's Poetry (Canceled)	0.0	canceled	4949.60	0.00	0.00
374855	1	Documentary	US	USD	2014-10-17	378656	50000.0	999976400	2014-09-17 02:35:30	Film & Video	ChknTruk Nationwide Charity Drive 2014 (Canceled)	25.0	canceled	50000.00	25.00	25.00
374856	5	Narrative Film	US	USD	2011-07-19	378657	1500.0	999977640	2011-06-22 03:35:14	Film & Video	The Tribe	155.0	failed	1500.00	155.00	155.00
374857	1	Narrative Film	US	USD	2010-08-16	378658	15000.0	999986353	2010-07-01 19:40:30	Film & Video	Walls of Remedy- New lesbian Romantic Comedy f...	20.0	failed	15000.00	20.00	20.00
374858	6	Technology	US	USD	2016-02-13	378659	15000.0	999987933	2016-01-13 18:13:53	Technology	BioDefense Education Kit	200.0	failed	15000.00	200.00	200.00
374859	17	Performance Art	US	USD	2011-08-16	378660	2000.0	999988282	2011-07-19 09:07:47	Art	Nou Renmen Ayiti! We Love Haiti!	524.0	failed	2000.00	524.00	524.00

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows